﻿
--分类属性表  Property：
--详细产品的的指定分类值

CREATE TABLE [dbo].[T_ClassPropertyValue](
	[F_AutoId] [int] IDENTITY(1,1) NOT NULL,--辅助自动ID(预留)
	[F_ClsProValId] Int Default(0) NOT NULL,--主键
	[F_ClsProId] Int Default(0) NOT NULL,
	[F_ClsAppId] Int Default(0) NOT NULL,--(分类ID)  对应 T_ClassAppendValueValue==>[F_ClsAppId]
	[F_ProductId] Int Default(0) NOT NULL,--产品ID

	[F_Value] varchar(500) NOT NULL,--值
	CONSTRAINT [PK_T_ClassPropertyValue] PRIMARY KEY CLUSTERED
(
	[F_ClsProValId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [IX_MC_T_ClassAppendValueValue_F_ClsAppId] ON [dbo].[T_ClassAppendValueValue]
(
	[F_ClsProId] DESC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_MC_T_ClassAppendValueValue_F_ClsAppId] ON [dbo].[T_ClassAppendValueValue]
(
	[F_ClsAppId] DESC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_MC_T_ClassAppendValueValue_F_ProductId] ON [dbo].[T_ClassAppendValueValue]
(
	[F_ProductId] DESC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
GO
